Mega Code Archive

Categories
1) Android
2) ASP.Net
3) ASP.Net Tutorial
4) C
5) C Tutorial
6) C#
7) C# Book
8) C# by API
9) C# Tutorial
10) C++
11) C++ Tutorial
12) Delphi
13) Flash ActionScript
14) Flex
15) Java
16) Java Book
17) Java by API
18) Java Tutorial
19) JavaScript DHTML
20) JavaScript Reference
21) JavaScript Tutorial
22) MSOfficeExcel 2007 Tutorial
23) MSOfficePowerPoint 2007 Tutorial
24) MSOfficeWord 2007 Tutorial
25) MSSQL
26) MSSQL Tutorial
27) MySQL
28) MySQL Tutorial
29) Oracle PLSQL
30) Oracle PLSQL Tutorial
31) Perl
32) Php
33) PostgreSQL
34) Python
35) Python Tutorial
36) Ruby
37) Silverlight
38) VB.Net
39) VB.Net by API
40) VB.Net Tutorial
41) Visual C++ .NET
42) VisualBasic Script
43) XML
44) XML Tutorial

 

MSSQL
1) Aggregate Functions
2) Analytical Functions
3) Constraints
4) Cursor
5) Data Set
6) Data Type
7) Database
8) Date Timezone
9) Index
10) Insert Delete Update
11) Math Functions
12) Select Query
13) Sequence
14) Store Procedure Function
15) String Functions
16) Subquery
17) System
18) Table
19) Table Joins
20) Transact SQL
21) Transaction
22) Trigger
23) View
24) XML

Transact SQL
1) @@VERSION
2) A simple example of the @@ERROR variable
3) Assign query result to a variable
4) Assign value from select statement to a variable
5) Assign value returned from a aggregate function to a variable with set statement
6) Assign value to a variable
7) Assigning Values with the Select Statement
8) ATAN
9) BREAK exits the WHILE structure, resuming execution after the END statement
10) BREAK stops the execution of the statements inside the block
11) Build and call dynamic statement
12) CAST @@ROWCOUNT as varchar
13) Checks for existing Product record
14) COALESCE()
15) Conditional Logic IF
16) CONTINUE stops only the current execution
17) Continue statement Demo
18) Create a Stored Procedure that raises an error
19) Create dynamic sql from user name and date
20) Create procedure to update table based on parameters passed in
21) Creating a Trigger and raise an error
22) Creating Inline User-Defined Functions
23) Declare a varchar variable
24) Declare a variable
25) Declares a local variable (@intvar) and then assigns a value to the variable
26) Define table variable
27) Delete in a stored procedure
28) Do calculation in a procedure
29) Do calculation in update statement in a procedure
30) Dynamically set the number of rows returned
31) ELSE
32) Error Handling in SQL Server 2005
33) Function to pass an array
34) Get Object property for a function
35) Get return row count
36) Grouping Code into Blocks
37) raise errors
38) IF and else IF
39) If and else if statement
40) IF and EXISTS function
41) If else statement
42) If statement
43) Insert all statements in a batch or to roll back the entire statement group if an error occurs
44) Insert command and variables
45) Insert data to a table in the procedure
46) Legal custorderdetails Inline Table-Valued Function
47) Local variable must be defined using the DECLARE statement
48) Log
49) LOG is the inverse of EXP, and this can be demonstrated by
50) Looping with the WHILE Statement
51) Managing Inserts Using Stored Procedures
52) Not equal sign
53) Not equal sign in SQL Server
54) Print
55) Reference variables in SQL statement
56) Returning Values
57) Rollback transaction on error
58) Select clause as a statement
59) SELECT is usually used to assign variable values
60) Set value from select statement to a variable
61) Stored procedure
62) System schemas
63) Table Variables
64) The second query waited until the next instance of the specified time
65) Update data and table join
66) Update data set returning from the function
67) Update two tables in one procedure
68) Use @Error
69) Use aggregate function in dynamic sql statement
70) Use declared variable in SQL statement
71) Use return statement to return a table from a function
72) Use while loop to insert data
73) Using @@ROWCOUNT
74) Using a dynamic sql statement in Insert select
75) Using GOTO
76) Using RETURN
77) Using SELECT to Assign Variables
78) Using SET to Assign Variables
79) Using Variables with Functions
80) Using WAITFOR
81) When multiple lines of code follow an IF statement it is best to wrap the lines in a BEGIN END block
82) While Loop Demo
83) While loop with counter
84) While with aggregate function